/**
 * Copyright 2009 Emory University
 * 
 * Permission is hereby granted, free of charge, to any person obtaining a
 * copy of this software and associated  * documentation files (the 
 * "Software"), to deal in the Software without
 * restriction, including without limitation the rights to use, copy, modify,
 * merge, publish, distribute, sublicense, and/or sell copies of the Software,
 * and to permit persons to whom the Software is furnished to do so, subject to
 * the following conditions: The above copyright notice and this permission
 * notice shall be included in all copies or substantial portions of the
 * Software. 
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO
 * EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES
 * OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
 * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
 * DEALINGS IN THE SOFTWARE.
 */
package com.markgrand.structuredSql;

/**
 * Abstractly model a FOR UPDATE clause or similar construct such as FOR SHARE 
 * or FOR READ ONLY.
 *
 * @author Mark Grand
 */
abstract class SelectForClause() extends SQLAppender {
  val tableNames:Seq[TableName]
  val updatability:String
  
  /**
   * Append an SQL syntax compliant representation of this column identifier 
   * to the given StringBuilder object.
   */
  def append(builder : StringBuilder) {
    builder.append("FOR ")
    builder.append(updatability)
    val tableNameIterator = tableNames.iterator
    if (tableNameIterator.hasNext) {
      builder.append(" OF ")
      tableNameIterator.next.append(builder)
      while (tableNameIterator.hasNext) {
        builder.append(",")
        tableNameIterator.next.append(builder)
      }
    }
  }
}
